from openpyxl import Workbook
wb = Workbook()
ws = wb.active
cell = ws["A1"]
cell.value = '100'

# 这个是 6行 1列 就是A6
cell = ws.cell(6, 1,100)
cell.value = 100

print(f'cell的值:{cell.value}')
print(f'cell的单元:{cell.coordinate}')
print(f'cell的行:{cell.row}')
print(f'cell的列数:{cell.column}')
print(f'cell的列字母:{cell.column_letter}')


# wb.save(r'D:\Desktop\exceltest\my3.xlsx')